Mega Code Archive

Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial

 

MSSQL Tutorial
1) Aggregate Functions
2) Analytical Functions
3) CLR
4) Constraints
5) Cursor
6) Data Convert Functions
7) Data Types
8) Database
9) Date Functions
10) Index
11) Insert Delete Update
12) Math Functions
13) Procedure Function
14) Query
15) Sequence Indentity
16) Set Operations
17) String Functions
18) Subquery
19) System Functions
20) System Settings
21) System Tables Views
22) Table
23) Table Join
24) Transact SQL
25) Transaction
26) Trigger
27) User Role
28) View
29) XML

Aggregate Functions
1) A common mistake with DISTINCT is to code the DISTINCT statement before the COUNT statement
2) A summary query that uses the COUNT, AVG, and SUM functions
3) A summary query that uses the MIN and MAX functions
4) A summary query that works on non-numeric columns
5) Adds the WHERE statement to calculate the average
6) Aggregate function in sub query
7) Aggregate function, order by desc, group by
8) Aggregate functions are applied to a group of data values from a column
9) AVG calculates the average for selected records of numeric data in a column or the average for DISTINCT (unique) value
10) CAST(AVG(dec1) AS dec(5,2))
11) Count function with column alias
12) COUNT returns the total count of records in a column or the count for DISTINCT (unique) values selected by the query.t
13) Count table row in dynamic sql
14) COUNT() returns the total count of all records (rows) in the column, including NULL values of selected records by the
15) Counting unique values
16) Counting values including NULL values
17) Finding the Earliest Date Using MIN()
18) Finding the First Order for Each Customer Using MIN()
19) Finding the Last Row in Employee Using MAX()
20) Finding the smallest and largest selling prices
21) HAVING SUM(Salary) 1000
22) Id = (SELECT MIN(id) FROM employee)
23) MAX returns the largest value in a column of all selected records by the query of any char, number, or datetime dataty
24) MIN returns the smallest value in a column of all selected records by the query of any char, number, or datetime datat
25) Query Using MIN() and MAX() on Same Column
26) Query with aggregate function as a column
27) RANK() OVER
28) Returning Rows by Rank Without Gaps
29) Selecting titles that sell more than the average
30) Sum function with column alias
31) SUM returns the total value in a column of all selected records or all the DISTINCT (unique) values selected by the qu
32) Sum with CUBE
33) SUM with group by
34) SUM with WITH ROLLUP
35) The RANK() function preserves the ordinal position of the row in the list
36) The use of the aggregate function MAX in subquery
37) Using Aliase with aggregate function
38) Using calculations within aggregate functions
39) Using DISTINCT in Aggregate Functions
40) Using ISNULL to count all values including NULLs